﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="SupplierOrderList.ascx.cs" Inherits="webUserControl_SupplierOrderList" %>
<%@ Register assembly="Infragistics2.WebUI.UltraWebGrid.v8.1, Version=8.1.20081.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid" tagprefix="igtbl" %>
<%@ Register assembly="Infragistics2.WebUI.UltraWebGrid.ExcelExport.v8.1, Version=8.1.20081.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid.ExcelExport" tagprefix="igtblexp" %>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:LinFen %>" 
    SelectCommand="SELECT ID AS 编号, NumMale AS 男, NumFemale AS 女, NumHongGan AS 烘干机, NumBaoJian AS 包间, NumQiTa AS [其他/消防点位], endTime AS 结束时间, DangCiName AS 档次, ClassName AS 分类, isType AS 类型, CustomerName AS 客户名, CustomerTelPhone AS 电话, CustomerLinkMan AS 联络人, SupplierName AS 点位名称, SupplierName2 AS 楼层, CityName AS 城市, DistrictName AS 地区, Addre AS 地址, Linkman AS 点位联络人, TelPhone AS 电话 FROM vw_OrderDetail WHERE (SupplierID = @SupplierID) AND (Status = @Status)">
    <SelectParameters>
        <asp:QueryStringParameter Name="SupplierID" QueryStringField="sID" 
            Type="Int32" />
        <asp:Parameter DefaultValue="0" Name="Status" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" 
    DataSourceID="SqlDataSource1" Height="500px" Width="100%">
    <bands>
        <igtbl:UltraGridBand>
            <Columns>
                <igtbl:UltraGridColumn BaseColumnName="编号" DataType="System.Int32" 
                    IsBound="True" Key="编号">
                    <Header Caption="编号">
                    </Header>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="男" DataType="System.Int32" 
                    IsBound="True" Key="男">
                    <Header Caption="男">
                        <RowLayoutColumnInfo OriginX="1" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="1" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="女" DataType="System.Int32" 
                    IsBound="True" Key="女">
                    <Header Caption="女">
                        <RowLayoutColumnInfo OriginX="2" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="2" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="烘干机" DataType="System.Int32" 
                    IsBound="True" Key="烘干机">
                    <Header Caption="烘干机">
                        <RowLayoutColumnInfo OriginX="3" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="3" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="包间" DataType="System.Int32" 
                    IsBound="True" Key="包间">
                    <Header Caption="包间">
                        <RowLayoutColumnInfo OriginX="4" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="4" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="其他/消防点位" DataType="System.Int32" 
                    IsBound="True" Key="其他/消防点位">
                    <Header Caption="其他/消防点位">
                        <RowLayoutColumnInfo OriginX="5" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="5" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="结束时间" DataType="System.DateTime" 
                    IsBound="True" Key="结束时间">
                    <Header Caption="结束时间">
                        <RowLayoutColumnInfo OriginX="6" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="6" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="档次" IsBound="True" Key="档次">
                    <Header Caption="档次">
                        <RowLayoutColumnInfo OriginX="7" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="7" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="分类" IsBound="True" Key="分类">
                    <Header Caption="分类">
                        <RowLayoutColumnInfo OriginX="8" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="8" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="类型" IsBound="True" Key="类型">
                    <Header Caption="类型">
                        <RowLayoutColumnInfo OriginX="9" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="9" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="客户名" IsBound="True" Key="客户名">
                    <Header Caption="客户名">
                        <RowLayoutColumnInfo OriginX="10" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="10" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="电话" IsBound="True" Key="电话">
                    <Header Caption="电话">
                        <RowLayoutColumnInfo OriginX="11" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="11" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="联络人" IsBound="True" Key="联络人">
                    <Header Caption="联络人">
                        <RowLayoutColumnInfo OriginX="12" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="12" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="点位名称" IsBound="True" Key="点位名称">
                    <Header Caption="点位名称">
                        <RowLayoutColumnInfo OriginX="13" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="13" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="楼层" IsBound="True" Key="楼层">
                    <Header Caption="楼层">
                        <RowLayoutColumnInfo OriginX="14" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="14" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="城市" IsBound="True" Key="城市">
                    <Header Caption="城市">
                        <RowLayoutColumnInfo OriginX="15" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="15" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="地区" IsBound="True" Key="地区">
                    <Header Caption="地区">
                        <RowLayoutColumnInfo OriginX="16" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="16" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="地址" IsBound="True" Key="地址">
                    <Header Caption="地址">
                        <RowLayoutColumnInfo OriginX="17" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="17" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="点位联络人" IsBound="True" Key="点位联络人">
                    <Header Caption="点位联络人">
                        <RowLayoutColumnInfo OriginX="18" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="18" />
                    </Footer>
                </igtbl:UltraGridColumn>
                <igtbl:UltraGridColumn BaseColumnName="电话1" IsBound="True" Key="电话1">
                    <Header Caption="电话1">
                        <RowLayoutColumnInfo OriginX="19" />
                    </Header>
                    <Footer>
                        <RowLayoutColumnInfo OriginX="19" />
                    </Footer>
                </igtbl:UltraGridColumn>
            </Columns>
            <addnewrow view="NotSet" visible="NotSet">
            </addnewrow>
        </igtbl:UltraGridBand>
    </bands>
    <displaylayout allowcolsizingdefault="Free" allowcolumnmovingdefault="OnServer" 
        allowdeletedefault="Yes" allowsortingdefault="OnClient" 
        allowupdatedefault="Yes" bordercollapsedefault="Separate" 
        headerclickactiondefault="SortMulti" name="ctl00xUltraWebGrid1" 
        rowheightdefault="20px" rowselectorsdefault="No" 
        selecttyperowdefault="Extended" stationarymargins="Header" 
        stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00" 
        viewtype="OutlookGroupBy">
        <framestyle backcolor="Window" bordercolor="InactiveCaption" 
            borderstyle="Solid" borderwidth="1px" font-names="Microsoft Sans Serif" 
            font-size="8.25pt" height="500px" width="100%" ForeColor="Black">
        </framestyle>
        <pager minimumpagesfordisplay="2">
            <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
            <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                widthtop="1px" />
            </PagerStyle>
        </pager>
        <editcellstyledefault borderstyle="None" borderwidth="0px">
        </editcellstyledefault>
        <footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">
            <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                widthtop="1px" />
        </footerstyledefault>
        <headerstyledefault backcolor="LightGray" borderstyle="Solid" 
            horizontalalign="Left">
            <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                widthtop="1px" />
        </headerstyledefault>
        <rowstyledefault backcolor="Window" bordercolor="Silver" borderstyle="Solid" 
            borderwidth="1px" font-names="Microsoft Sans Serif" font-size="8.25pt">
            <padding left="3px" />
            <borderdetails colorleft="Window" colortop="Window" />
        </rowstyledefault>
        <groupbyrowstyledefault backcolor="Control" bordercolor="Window">
        </groupbyrowstyledefault>
        <groupbybox prompt="拖拽一列到这里进行排版、排序。">
            <boxstyle backcolor="ActiveBorder" bordercolor="Window">
            </boxstyle>
        </groupbybox>
        <addnewbox hidden="False">
            <boxstyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid" 
                borderwidth="1px">
                <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                    widthtop="1px" />
            </boxstyle>
        </addnewbox>
        <activationobject bordercolor="" borderwidth="">
        </activationobject>
        <filteroptionsdefault>
            <filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid" 
                borderwidth="1px" customrules="overflow:auto;" 
                font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px" height="300px" 
                width="200px">
                <padding left="2px" />
            </filterdropdownstyle>
            <filterhighlightrowstyle backcolor="#151C55" forecolor="White">
            </filterhighlightrowstyle>
            <filteroperanddropdownstyle backcolor="White" bordercolor="Silver" 
                borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;" 
                font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">
                <padding left="2px" />
            </filteroperanddropdownstyle>
        </filteroptionsdefault>
    </displaylayout>
</igtbl:UltraWebGrid>
<igtblexp:UltraWebGridExcelExporter ID="UltraWebGridExcelExporter1" 
    runat="server">
</igtblexp:UltraWebGridExcelExporter>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
    Text="导出Excel" />
&nbsp;<asp:Button ID="btnResize" runat="server" onclick="btnResize_Click" 
    Text="释放该点位所有绑定" />
